UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sip6FrBAa9lzCH0IKsYWrDO9Xc4Rmu900+A0A3PIHlo='
WHERE
key_id = 'bc00ef7cd625ca7e87541c8ce5f6329d44a9a9120d501c9eafae476c46557be2'
AND (
token = 'Sip6FrBAa9lzCH0IKsYWrDO9Xc4Rmu900+A0A3PIHlo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)