UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AHTuV7+0s7+VxT6VC5aBN6AIATwwGObmsd/n3IcvNGI='
WHERE
key_id = 'fde5b5aa268a66211fb41136943cd95172f4d5b6dbfb5a80ddaf2f866d1d8167'
AND (
token = 'AHTuV7+0s7+VxT6VC5aBN6AIATwwGObmsd/n3IcvNGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)