UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WkPAFTnYUwHp6hgGVq7fgRu8BBl2MzBAVn62jsORaCs='
WHERE
key_id = 'c1d2e634039085261ebd00bb19f4bf89e5e7564920d47b0a5f655f01226cffca'
AND (
token = 'WkPAFTnYUwHp6hgGVq7fgRu8BBl2MzBAVn62jsORaCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)