UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kk2iYK8DCiLHXPX29myZBap9VPlrtdWaAFamrt8qjL8='
WHERE
key_id = '7a4db5ec1bbac2acec1347d9fbaad25435f8eb3e43059545a31b5394251e5361'
AND (
token = 'kk2iYK8DCiLHXPX29myZBap9VPlrtdWaAFamrt8qjL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)