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