UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qIpZMPh+kttweP3yIDuDax9SUhoH5fltV18Nm0EoxWM='
WHERE
key_id = '863c06a465f7f840bf1fa868a985939942051dc8ba703ddc299eca405b2bf503'
AND (
token = 'qIpZMPh+kttweP3yIDuDax9SUhoH5fltV18Nm0EoxWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)