UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/oH7pGLB+7lk+P4Y5mtF2cuFDAS9+nz9LKXvo5HVKM0='
WHERE
key_id = '195b8dfa8e39b433e5807daf3f13f9563c6ca5613a171360025c400b650fa0db'
AND (
token = '/oH7pGLB+7lk+P4Y5mtF2cuFDAS9+nz9LKXvo5HVKM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)