UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YfxrCuGUDXBRvRutKQYttho9Qal6aQ7N7fvo27g0Vwg='
WHERE
key_id = '0b8a1aabfa3f22ab3d72b1c6c9cdcd67e68d092c4120fb5b9665c1dc58f03ea8'
AND (
token = 'YfxrCuGUDXBRvRutKQYttho9Qal6aQ7N7fvo27g0Vwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)