UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qiBQ5B2TQGdl8HY0VYzmE3Fqu5e5Bj+8FAotgkITAX0='
WHERE
key_id = 'e336c86c4afcfcdc9310a3c756488ac89fa71c437206dbb0fe3774a267fb3409'
AND (
token = 'qiBQ5B2TQGdl8HY0VYzmE3Fqu5e5Bj+8FAotgkITAX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)