UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3AQcHafnHFzHJpcpe6VGSBNdthHDiXHWkPw+l+URJJ8='
WHERE
key_id = 'dcad892e47d1ec42b4d72717f391a7e5aa789f41d2222031854d92b0e4f7cde3'
AND (
token = '3AQcHafnHFzHJpcpe6VGSBNdthHDiXHWkPw+l+URJJ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)