UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+NzLA22hIXDXVC22w3UOjK22ff4QHDJ2Aq/TNLqKB0='
WHERE
key_id = 'fc25143ed6ce8b70f584ce9d9d18e247106b4e9356243f0e3f267f33f7d8fcc2'
AND (
token = 'z+NzLA22hIXDXVC22w3UOjK22ff4QHDJ2Aq/TNLqKB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)