UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I1CEiS/aVzfI1ZFhc2sAHGPZBpMdioNKXdP22FFRJao='
WHERE
key_id = 'e9306040e75b4397390e27b8e7f8c62a43f5ce55d2e6614b7df95a7e7b99989b'
AND (
token = 'I1CEiS/aVzfI1ZFhc2sAHGPZBpMdioNKXdP22FFRJao='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)