UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8csGbFOF6HXmdRMThy3gmBrtgpc4MdpQ6LCeE7h+Nx0='
WHERE
key_id = '2ce6307e658280c40eff2db9bcb51a7e57e824fb1acecddb9ef94df8fbb0ad8f'
AND (
token = '8csGbFOF6HXmdRMThy3gmBrtgpc4MdpQ6LCeE7h+Nx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)