UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ycGuJv8ddap89W7u5kUonalaMpAIOEBv0uOfodZTGkA='
WHERE
key_id = '99bbd0bf695bfe3c2c309b8e31863e417182b1fbe633eafc7d5966f116e934ab'
AND (
token = 'ycGuJv8ddap89W7u5kUonalaMpAIOEBv0uOfodZTGkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)