UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '10N9M/Zah97KxqM1VkFl2Z21DpYXNFX+5XxPMZp1+Ww='
WHERE
key_id = 'ed8cc1172095987146d86f8820581e0de10001613fdcfca1c4a101d0247ead0c'
AND (
token = '10N9M/Zah97KxqM1VkFl2Z21DpYXNFX+5XxPMZp1+Ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)