UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vZcdPezfbYEPpfokWxQdv0y9+3pbT278T3xh+DmtKFs='
WHERE
key_id = 'e806dfebcd70a91cb46945a59fbad90548161c1a7a7060d06407a04d07660764'
AND (
token = 'vZcdPezfbYEPpfokWxQdv0y9+3pbT278T3xh+DmtKFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)