UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8hU57vq8gsvb6k/XvWPmuw66AI4Va1C5NUdeve7L+Yk='
WHERE
key_id = 'd3c45c931bce8681014c0b3e88a187a51ccf40c7f7e304f3ded17c9b5dd5bcaa'
AND (
token = '8hU57vq8gsvb6k/XvWPmuw66AI4Va1C5NUdeve7L+Yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)