UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJgWV+eeUWf2q5Aygt8LnMEZqMMkEPhOwulrKvcaFZ8='
WHERE
key_id = '42538e50ae499705f02dbf7fd446ea63e094c9618f1fab6eef3b170f6f978331'
AND (
token = 'BJgWV+eeUWf2q5Aygt8LnMEZqMMkEPhOwulrKvcaFZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)