UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLrhyc3oa3cPlwuZM1KCnBCFwPYNZUgElbRG7+IQE1s='
WHERE
key_id = 'f943d753bf817235eb037befc28c3603fd4a4231792ddff48c3afabd87e1cd82'
AND (
token = 'pLrhyc3oa3cPlwuZM1KCnBCFwPYNZUgElbRG7+IQE1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)