UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WKx8BOevdad6vstuJ77eZWXS0iDVz/WFX7yucO10JBE='
WHERE
key_id = 'b120fe28e493465e5b51bc5656287d8189bd11b2c1ee00e2a5fedb51c48f952a'
AND (
token = 'WKx8BOevdad6vstuJ77eZWXS0iDVz/WFX7yucO10JBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)