UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9x6KrqLabMVgPvcWECkrSFztE8t+f7q+SS5nJy+O60='
WHERE
key_id = 'e818c1df55600e9727147d43cbc61e794840c8411d7d563a142bcc2030bc4810'
AND (
token = 'J9x6KrqLabMVgPvcWECkrSFztE8t+f7q+SS5nJy+O60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)