UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ThWUDBUJI5mDMVs09dPK/n9wAe8juICtcyYDcSMlikU='
WHERE
key_id = 'd1eb129cece72c2127dfa1af6dacfa7bcd2c42e14d6bb57a803a4473887b06dc'
AND (
token = 'ThWUDBUJI5mDMVs09dPK/n9wAe8juICtcyYDcSMlikU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)