UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l8CPWo4TN2xYmEC88K+v8pcbgnizP8x/eaWFQw6mypM='
WHERE
key_id = 'caf2d2b27c6fa3e6c730ede909bed5477335d672c4b18e13c7176d736b478c6c'
AND (
token = 'l8CPWo4TN2xYmEC88K+v8pcbgnizP8x/eaWFQw6mypM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)