UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lxAMnHPKKzfSnCh16BEU7D3t2JtJn4SRSWKf5yxCxdg='
WHERE
key_id = '8003a8e3190a7e5eaba002b551a5f0a8f21150bae8de25d60ebd1d4d5f0ed6ef'
AND (
token = 'lxAMnHPKKzfSnCh16BEU7D3t2JtJn4SRSWKf5yxCxdg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)