UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '80cp2tUJPeqvZNrQ1YFigTJFsOBRp80sUW0CPy6SKtU='
WHERE
key_id = '9a80f1a56f635b1882359bd1fdbd292463294b47d1560619fe186492aa1cad28'
AND (
token = '80cp2tUJPeqvZNrQ1YFigTJFsOBRp80sUW0CPy6SKtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)