UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qrcSepKWm4IJjEG3z4Dykrd+OIW3NqS/dizraI2woZE='
WHERE
key_id = 'b49b49b9ebbdc380bf4aa6ccf96abdb27c4586c336258defc91e9cc89ca06868'
AND (
token = 'qrcSepKWm4IJjEG3z4Dykrd+OIW3NqS/dizraI2woZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)