UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bg96vvPa6ne7NOJa2GopWWo2tM9chFcahJbJJ1T11Ic='
WHERE
key_id = 'bb7e8006099fd054025907a8d9c9bbdeab0b9042774f8aa83df2fbcae6d1a513'
AND (
token = 'Bg96vvPa6ne7NOJa2GopWWo2tM9chFcahJbJJ1T11Ic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)