UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CqEMY4I31O6a0LUWcJOTYG6cuB+oWo+9mN96AsLAG6c='
WHERE
key_id = 'a78e15fb66855bd0639f6ca9120af9f78cf2e0c7bf80717dfec35b54d5369a5f'
AND (
token = 'CqEMY4I31O6a0LUWcJOTYG6cuB+oWo+9mN96AsLAG6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)