UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Ys5IDMwm0D3TpcZ1E46VGuwR8v2qd+LsHOmrc6utk0='
WHERE
key_id = '18d7f57975d5a88c11b21e7bd41daad11b27ab8d3b684b9791b60f77ef9b5394'
AND (
token = '3Ys5IDMwm0D3TpcZ1E46VGuwR8v2qd+LsHOmrc6utk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)