UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MZhuHFR0eb3D/S5rumPG3TiseURGv/nIFkK4VG6jlg='
WHERE
key_id = 'c06a8f1b88abad90c567c1def7a30b822b51d30f25c1e757db09ae6f957fe2ee'
AND (
token = '8MZhuHFR0eb3D/S5rumPG3TiseURGv/nIFkK4VG6jlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)