UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WUwiwYgqHBAUDkXNLOtz+pkYOTDMpaLd96B7yRpldYU='
WHERE
key_id = '1e3d6c37fa82d2ae9a115fd16153b431e2ac67481fc9fa4be1d45934b699b584'
AND (
token = 'WUwiwYgqHBAUDkXNLOtz+pkYOTDMpaLd96B7yRpldYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)