UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i75OfTud3OWYX7R1jSthQ/wkEdX9s9NOceFIa3ovV3c='
WHERE
key_id = 'b547c8514382839de4c087bd7eff9fd45341427dfa0c87012abb02c2b6a6f5eb'
AND (
token = 'i75OfTud3OWYX7R1jSthQ/wkEdX9s9NOceFIa3ovV3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)