UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CLqdVIBRr3DL8NF8Djyb0eBpyz3zBlkCSAkF/DoX5KE='
WHERE
key_id = 'bc8dcab142953362539820edaa499a5f0ba565a8473eceea468544f9f1d782df'
AND (
token = 'CLqdVIBRr3DL8NF8Djyb0eBpyz3zBlkCSAkF/DoX5KE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)